SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 463313 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 463313 [ RunTime:0.001662s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (898471,1030693,954493,249410,432725,700879,352036,455010,919202,965115,636434,906017,59607,995933,426300,916018,387901,160825,649127,589172,906643,143883,33184,699193,799998,868461,828322,334668,288680,933434,554666,518918,444672,223650,991305,425015,986034,535998,989042,671320,497472,1019179,69093,260186,287756,443420,189273,232943,460071,525059,933923,219610,203314,881654,757027,718568,823105,896600,876282,799835) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 463313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 463313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]