SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 214180 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 214180 [ RunTime:0.001833s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (39616,398559,474420,317232,389248,822993,146344,158642,871202,894741,199120,994293,335937,1025503,485336,151761,989828,47745,775992,1045915,796033,853615,925720,983398,238249,330780,135548,230132,418110,403871,363682,118807,671814,570307,958696,185973,908804,704337,617489,81923,934181,566560,189373,999765,840145,453427,604319,985260,427444,463476,1021350,320729,392658,995718,97358,537545,816358,158768,260854,214485) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 214180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 214180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000422s ]