SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001448s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538091 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538091 [ RunTime:0.002400s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (474332,704633,985081,760359,297759,884081,821755,39904,414456,319619,552866,279345,478491,115535,842901,42546,297960,156840,723118,692946,166457,322694,399163,719184,23347,659119,256293,1028828,803490,261473,861437,723599,777521,807313,332979,533805,7044,609076,819696,409268,984974,156637,204754,402563,143572,114161,323278,643022,198003,95158,575462,335268,30937,393846,946538,666779,329238,467923,776710,407356) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001321s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000574s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000651s ]