SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451234 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451234 [ RunTime:0.002203s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (54808,833693,672115,430472,172059,675389,16736,921609,32399,818093,684844,667743,884037,930007,66788,87194,24751,271173,635506,210061,377334,716579,497328,512700,33718,413445,126700,214928,92764,571109,921076,42385,230655,256760,240192,67634,1594,891288,685301,530341,985525,190188,650739,189742,201599,664776,614230,881234,703663,746135,41193,1039954,411256,720704,45580,370290,767523,179183,121989,232287) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001578s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451234 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451234 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001353s ]