SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001488s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 918038 LIMIT 1 [ RunTime:0.004655s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 918038 [ RunTime:0.008462s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (516855,402707,313553,494150,826394,658518,277822,579682,982242,523628,41697,681416,59156,1021250,390046,367042,467723,513769,671447,705041,278710,466624,206006,159527,54160,884952,400481,726927,620131,756646,563570,822176,487282,419627,311568,379548,977931,202370,960117,1030416,167640,351250,266197,831214,665200,467526,771760,587318,44243,993658,804400,717817,945021,1031878,205511,448787,601904,330506,272427,503) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 918038 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 918038 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]