SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 640091 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 640091 [ RunTime:0.002664s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (583262,241358,843904,14351,311488,895980,927341,110362,989269,555656,1014686,577865,283333,323234,453912,445481,656985,890904,14274,875942,1035318,834767,55768,263906,1038102,790992,406219,114380,372282,912480,792009,547865,263561,216194,736453,836767,975218,1033410,942495,228517,451594,532725,168059,307247,876753,524528,27094,864391,840323,947893,467065,765824,868076,37551,618996,316937,888392,362758,1034806,566326) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 640091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 640091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]