SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545903 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545903 [ RunTime:0.002549s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (176965,999680,616895,968851,63068,567501,199378,663021,218419,923911,484196,754209,638741,903416,620786,503826,944599,760862,518192,9502,755489,959591,253344,216615,571218,283752,810288,714793,363698,250251,146097,497431,471431,422684,229991,899791,487697,358659,63339,606026,258400,500828,50832,630517,207467,1046517,375261,281075,517002,910103,295838,172952,2739,979488,108450,1014995,359059,718024,378018,535370) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545903 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545903 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]