SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491099 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491099 [ RunTime:0.001740s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (383530,299799,299661,169560,588808,524822,549061,1036519,582314,695481,797237,637624,88889,78404,108960,295425,829902,12985,841105,207594,859396,876319,718107,112016,594013,903163,759276,989892,510438,903517,23983,177379,178890,606403,858774,117864,846276,242637,1026184,688957,73313,1009715,852756,258666,604826,823066,351692,187656,890005,481482,651893,989064,408630,269135,654602,854588,430176,903204,315174,206749) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000927s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491099 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491099 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]