SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001410s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 590003 LIMIT 1 [ RunTime:0.000466s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 590003 [ RunTime:0.002985s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (928110,903718,434017,300941,473802,72407,805586,758364,904828,986750,890514,589437,222524,876102,712171,116813,646442,98635,330969,1023623,466180,55373,826165,230190,366232,205813,264033,806343,123058,306647,361865,629491,561228,771072,509918,715282,918888,764191,1006084,864640,534170,61772,446038,717606,820735,247883,940971,294421,99795,295314,1046078,26757,374263,685917,800041,49760,921772,807419,738072,513350) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003845s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 590003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000556s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 590003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001510s ]