SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001367s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 903412 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 903412 [ RunTime:0.001895s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (610045,336113,482975,1024738,36559,140890,505971,363391,676381,86092,564913,431576,505965,948132,162575,452698,319319,869485,373922,861106,709976,378179,342261,188521,48843,493988,150552,512608,112076,251886,745569,742171,1013523,328803,358260,414652,799608,653245,226736,821989,505451,61313,280954,556619,796256,336573,470305,388993,651855,427138,393720,76595,563294,711199,215046,545547,691935,717180,678014,677961) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 903412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 903412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]