SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802621 LIMIT 1 [ RunTime:0.005012s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802621 [ RunTime:0.001917s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (584850,1005543,593159,18943,1020971,557664,501703,247768,552264,491195,576989,280328,276852,718056,835135,526804,115723,966064,444877,398886,433478,712957,295035,237987,128223,650125,201333,69380,1027368,422171,438475,786326,476820,106364,1021439,557729,441903,1001061,1019538,47737,13897,783901,609737,644613,516983,914725,878864,875557,833426,715530,1003600,614522,612750,399121,1040668,926874,685033,1030232,125902,365025) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802621 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.006029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802621 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]