SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426482 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426482 [ RunTime:0.001688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (858362,423820,602781,82682,508444,1035049,69917,201643,477343,90694,980561,229786,168734,198248,387284,529587,705087,909470,216802,21112,7299,424720,846923,171639,407760,403118,1042770,257431,5288,70828,138621,728995,674982,513279,690053,501800,549097,453269,933504,862542,705159,847915,543876,593513,76847,112225,728634,178883,137049,1004012,954516,604873,389347,185335,938472,270508,171415,154123,526778,89980) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426482 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426482 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]