SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 577409 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 577409 [ RunTime:0.001810s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (42453,271688,945719,285748,856485,386686,251309,426341,49339,9395,222676,864274,901537,975421,553944,169621,662747,160838,730897,748585,344839,931816,528038,357669,111132,377843,242609,1015341,666295,1026358,978995,433849,578646,926957,155825,917191,714930,381276,809308,762700,52894,407276,103490,797745,29111,447936,126857,410490,874006,775553,398607,1015548,54544,530584,388090,54785,101888,305470,122947,424178) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001750s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 577409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 577409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000762s ]