SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000993s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 250104 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 250104 [ RunTime:0.002099s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (198248,762120,377050,213545,118621,107048,638440,796582,890780,742945,394615,874868,644911,458274,883415,689170,882047,1006799,371932,673728,964562,945326,436670,217851,978819,803992,448614,758306,338491,39616,966252,1039354,255207,124471,680864,633950,519646,662718,679183,878045,530593,813925,793237,81553,564740,500893,1027752,487977,1000460,783799,1045851,163413,521203,629446,160135,685340,423613,684311,425945,588684) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 250104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 250104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]