SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563907 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563907 [ RunTime:0.002997s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1013324,256227,437314,184712,732863,844827,520090,524863,889390,118684,783180,927522,936674,244925,721025,851552,21958,403803,731793,506959,933162,229014,959107,148059,493483,453073,755262,505063,543509,663517,55517,72686,589728,561816,933041,749293,591465,997597,819759,631202,923121,520666,636745,643913,515005,314469,826248,782321,613919,951488,357297,74864,705552,761955,3868,533049,1038680,222783,531515,343892) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563907 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563907 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]