SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 282307 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 282307 [ RunTime:0.001766s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (800655,245815,579264,1017508,56293,300310,114900,385116,1010109,720959,718475,852863,130774,336218,217525,86653,138971,394527,806918,272783,376927,640188,230095,774252,624394,417123,759463,83142,237922,1041376,81269,922235,842231,975843,51856,122982,247905,12531,668560,314266,362754,980894,737030,706595,744615,622059,711155,271143,188023,676829,238494,1021054,199051,622505,146324,283562,804346,612801,1026039,184223) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 282307 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 282307 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]