SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 840680 LIMIT 1 [ RunTime:0.000962s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 840680 [ RunTime:0.001772s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (441987,502234,436774,463642,456556,147907,429863,33904,94842,277496,51996,12875,133518,219718,510608,558158,964826,781872,103454,203339,334448,668969,132953,1023209,250039,390800,634550,32027,350808,158367,350047,636993,131270,640765,44730,963063,459542,623852,70930,18396,511965,996329,629247,117405,63477,333822,576776,436966,641900,116692,114575,224134,517938,79053,945869,681148,953665,997184,69348,1017374) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002825s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 840680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 840680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]