SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 562811 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 562811 [ RunTime:0.002509s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (72382,358119,1030864,280840,1048246,528320,49158,324948,236584,151676,1013496,278303,99469,413741,1007831,114062,111812,883158,1023575,741518,990414,126447,268801,103441,221465,134539,455138,75714,660207,914755,845118,194909,51789,46988,1029137,345248,784338,200643,796363,934886,330151,66907,1031248,254220,480057,898421,179229,1020146,9791,991894,214095,636261,565407,1008637,836254,142061,922554,825344,819526,103572) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 562811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 562811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]