SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509908 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509908 [ RunTime:0.001623s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (435698,69198,768088,44002,551636,4986,529219,41035,609122,593207,113636,423887,808850,452009,942319,277379,16624,75203,39166,912322,225654,786709,306724,1018899,147840,566515,623342,431952,573924,712855,503488,935022,1988,246324,186742,26578,464015,869584,970857,525423,528351,1016857,855378,700119,779873,497418,744442,48190,189177,925168,208988,421673,10591,625414,824952,664141,505130,173403,642746,83869) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000951s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509908 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509908 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]