SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038910 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038910 [ RunTime:0.001825s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (592385,925718,427730,695381,979247,426556,155312,908171,912941,612264,466577,641246,660495,577678,66175,766138,192855,62338,858569,41537,209491,537899,938536,829166,344292,430244,389156,124990,903514,185683,485607,964898,308540,13415,514927,266456,616455,103128,635481,877428,641349,234429,412008,539274,212306,483795,65003,800816,474909,249384,627093,100930,421215,209113,564648,170769,511751,568132,1008594,7847) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000696s ]