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` = 387596 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 387596 [ RunTime:0.001979s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (598760,865808,758610,1019026,180846,1000228,120413,191624,69647,733359,1032875,649366,266626,877657,23611,825039,720468,31163,313962,39836,51712,761840,759984,168429,702131,12485,861024,555718,866214,833041,538289,906176,786080,280603,199153,633068,436589,546827,60725,22306,727869,55673,375069,280815,982957,639906,130742,939728,515741,140071,924568,908978,439122,261650,734563,184631,902413,667114,714519,710288) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 387596 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 387596 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]