SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503378 LIMIT 1 [ RunTime:0.000284s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503378 [ RunTime:0.001724s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (868152,449129,876641,947484,526929,367918,10403,642065,456883,970756,901331,444710,572408,859446,290543,427427,924592,239246,957120,354009,816499,552049,284652,31589,374306,29707,1030252,512823,589524,918610,845349,687002,1025640,673386,808917,439591,9595,471734,128385,511628,546310,504822,226155,995648,685558,893767,861572,584180,88188,980379,576945,24283,499880,350210,520803,860621,358723,712284,863099,463669) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503378 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000579s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503378 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]