SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480609 LIMIT 1 [ RunTime:0.001713s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480609 [ RunTime:0.005500s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (253219,656699,118841,826354,335449,782712,855357,394560,974983,334872,27804,114623,359270,983453,468871,109804,557802,635455,523644,816825,513364,538448,322391,609301,886724,105051,365612,367920,436641,75503,877259,112485,988969,829572,206466,490564,762883,458907,990574,346703,1046643,301667,795268,384100,1047338,107536,604197,541090,396357,435921,811874,942168,763785,421654,377219,294696,534402,945221,210097,420632) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480609 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480609 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000402s ]