SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 392409 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 392409 [ RunTime:0.001499s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (287122,858854,653137,721570,314826,587798,281590,410611,810675,232131,710636,35856,214449,283965,233352,647854,537457,86483,986509,983301,343529,1034434,907903,906584,941324,657112,302842,660347,357583,1004094,581179,207482,962772,506942,394406,363582,157384,37305,541515,659289,113485,288425,249391,1008590,661172,814501,658808,207256,280227,537887,186190,79035,11440,955640,702759,500377,314553,197576,74438,16480) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 392409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 392409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]