SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 351430 LIMIT 1 [ RunTime:0.000276s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 351430 [ RunTime:0.001640s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (465080,990057,157593,297119,51126,330483,1026186,826689,92668,798904,670629,77597,909568,56337,1000443,576864,155569,383043,953938,363151,624974,973871,1031472,537242,64551,343976,638716,562489,713941,418382,335452,73059,105148,768245,907561,820435,1028934,465454,944453,29711,257324,577844,788067,1020765,852012,535237,42394,225553,99724,360536,500293,188181,83280,212212,23046,614425,797345,308668,9390,160336) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 351430 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 351430 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]