SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001610s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413966 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413966 [ RunTime:0.001437s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (43657,542843,198828,461689,195382,585719,1017503,423894,678040,454851,132990,784369,743506,25674,205215,823424,846201,695542,21378,697123,583275,107149,480855,511087,664662,277596,355453,375840,225254,902998,810964,449568,236816,69422,507429,709828,150898,373187,596641,808068,496294,1028200,182492,378759,606763,643814,228241,564039,793892,926498,569942,205390,898505,638336,451632,3591,846626,533100,681750,430138) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413966 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413966 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]