SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002039s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480078 LIMIT 1 [ RunTime:0.000583s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480078 [ RunTime:0.003320s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1013308,69011,500045,318343,365162,486446,832735,377430,308168,691100,177978,205030,162789,86393,402713,495774,814134,724747,324167,218804,88973,77397,444900,739597,264159,425460,580114,694792,236388,714627,860830,484414,503254,8247,436501,1014778,1011977,362099,503851,640945,535129,999417,493481,333244,501832,302030,959264,525611,1005757,757722,630507,588832,769457,896229,228770,450380,897786,283167,657263,800268) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001637s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480078 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480078 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000962s ]