SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001614s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 262340 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 262340 [ RunTime:0.002044s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (319710,364629,271966,385633,507500,531187,633653,909528,912229,584443,407358,99597,484944,668004,191993,514067,160878,55524,442597,534665,991156,835834,107561,662934,799234,981044,347789,263373,141459,359788,232263,841366,668644,848281,891580,282243,283232,281326,323213,141402,304457,391763,213487,124101,930216,301762,992945,333375,901916,481476,136342,934917,301668,276167,512932,751505,413409,417573,255288,223951) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 262340 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 262340 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]