SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405718 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405718 [ RunTime:0.001648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (644915,343203,516056,136804,377341,746986,1014086,8604,120216,765047,122604,970565,566113,976152,630137,918358,697181,331203,506680,245767,693671,1021489,993819,332197,434456,452417,771458,816228,686357,838289,272382,941397,910156,389462,126462,109852,698491,286412,192686,194931,434241,897132,450598,338342,439568,202533,781111,934347,605804,747776,529039,767033,238309,919156,790021,492560,701899,960152,374446,830974) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000353s ]