SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002749s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034111 LIMIT 1 [ RunTime:0.002520s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034111 [ RunTime:0.005640s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (260572,673458,566208,861877,366264,427903,9688,924179,691018,330247,586048,934014,1008568,866893,484412,863296,809237,734334,774258,648556,102329,286166,537142,128165,563094,123151,215424,274387,703092,937736,776624,129311,961064,447247,652744,634259,337442,22280,115573,716803,613066,616863,206107,174859,573618,873382,17431,305518,583882,1028043,373040,765671,346527,41462,802582,671984,835427,3198,644115,103273) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002916s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034111 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004789s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034111 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004174s ]