SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445089 LIMIT 1 [ RunTime:0.000672s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445089 [ RunTime:0.001999s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (392723,971304,812326,284636,1045935,953460,694442,234709,352978,892858,413273,362861,653781,459491,603247,977648,377952,297580,362215,84766,101454,650222,590197,357979,276774,650463,148298,381419,426094,630490,412661,448407,474302,280238,646668,703548,619964,344708,656707,352879,438968,827784,648377,1047063,16003,154112,653853,694077,660539,591626,919836,580534,179171,895242,975954,429835,759686,484767,219777,522767) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445089 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445089 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001389s ]