SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001619s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012159 LIMIT 1 [ RunTime:0.004224s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012159 [ RunTime:0.002363s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (390497,877072,500542,995033,198695,268621,264418,391406,804763,450453,185411,391355,280280,874373,660311,819098,787928,122348,287211,971520,978877,224780,257850,175458,235461,655269,35050,318708,310451,34407,410739,366103,1017330,421508,645120,469754,40323,373623,391024,623238,684789,725732,899993,936717,263160,749230,274168,207467,771528,541064,991202,351590,132614,563722,413920,597807,414381,509598,103946,23593) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012159 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012159 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002409s ]