SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001410s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 684713 LIMIT 1 [ RunTime:0.001403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 684713 [ RunTime:0.003507s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (523481,87688,339738,34166,658503,772324,119141,852517,405518,927618,659699,345072,310929,473056,414794,160929,318884,61842,584526,96546,403317,196021,996282,856769,207322,742996,230953,424016,721290,568789,936945,411042,610662,579674,499524,927425,1048639,56886,12609,869508,960407,646355,171505,648700,429922,971065,1004068,270220,191209,502394,954983,992654,150838,908297,752008,899337,289562,588913,694884,800686) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001913s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 684713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 684713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002871s ]