SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391769 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391769 [ RunTime:0.001779s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (447895,185563,57654,755672,1038087,378288,305234,304002,128471,26567,2499,822187,272186,151266,773711,585811,1006508,422838,976714,40630,156856,757763,668596,616178,276588,348803,253675,362329,269955,384468,695454,98270,903962,650832,870919,269448,103836,155592,972106,525897,57093,135467,800193,625082,280509,409542,45605,1003461,282577,188094,19680,889553,117537,1005391,620257,608025,176145,859735,297614,576866) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391769 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000507s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391769 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]