SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001321s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044645 LIMIT 1 [ RunTime:0.001435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044645 [ RunTime:0.003864s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (15594,2108,670568,221861,766546,100006,45110,344062,250303,294657,274188,423248,1003635,593709,927400,130350,850480,738976,301421,204426,805553,559129,311444,23419,4013,724862,44919,577552,722828,8368,3370,894314,299073,333498,489974,724004,1001570,852878,265213,175912,253129,298602,903513,290418,412188,540845,694744,497504,429422,874814,564082,172546,666964,54319,1012913,846941,962901,308565,289262,741089) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044645 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044645 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]