SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414477 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414477 [ RunTime:0.002180s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1041928,789252,630734,905552,312234,931848,382724,570418,11967,456938,288951,629360,1008134,727793,360833,738164,900550,991086,157528,946016,509035,3292,567918,927725,782037,456269,821947,771186,937059,89880,885728,488137,303462,340201,247444,167907,618656,137174,180972,472811,242712,599863,495301,1002990,114974,981028,108969,681027,90043,384585,791832,42269,716860,885675,895693,365839,1007718,529170,743333,1016096) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002741s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414477 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414477 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]