SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405022 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405022 [ RunTime:0.002011s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (384753,914340,888988,457069,761696,720766,313476,348201,31102,517807,178392,378175,259876,677721,565674,430149,562050,200021,214557,141936,596868,225676,429135,1018708,655110,1044352,604259,920786,606385,879954,1026978,848946,522416,1006268,666290,599299,445445,759695,250783,887831,364974,754826,361951,36706,8734,451897,659910,335559,117556,590940,66023,196562,328378,320459,575885,96112,1041899,77353,648114,534219) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405022 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405022 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]