SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003846s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 286883 LIMIT 1 [ RunTime:0.000961s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 286883 [ RunTime:0.004313s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (322811,731520,982778,167136,515836,1019774,37640,1003435,882583,758129,55821,357429,152221,493793,205775,691514,106461,552185,879480,23684,869753,804995,930841,993030,876233,40992,4816,729055,754375,535767,476814,874156,786751,667607,114782,615941,671429,461068,602339,495402,218527,388693,800153,835024,408653,862786,256919,688364,673924,136436,869587,639206,120689,865719,976642,144149,239116,836538,99997,329064) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008275s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 286883 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000757s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 286883 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002583s ]