SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475428 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475428 [ RunTime:0.003272s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (242533,294162,93179,942381,742205,504619,407988,586195,193890,206330,208402,311666,479292,975852,685629,259051,205290,801498,428238,884898,555848,619554,849393,408461,97775,668770,969642,637638,380766,300421,183603,335671,899523,666153,212983,507316,761545,154856,64108,638223,101016,930468,246285,97777,1039906,184683,891940,565986,1039941,842589,928941,980973,1015423,97051,47998,232925,685748,257355,805519,1033422) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475428 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000322s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475428 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001351s ]