SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001367s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201448 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201448 [ RunTime:0.003705s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (38313,162779,322875,950573,981172,276738,896009,271779,777891,484693,402431,207477,1004256,886634,315740,187950,393349,523209,984141,985963,134460,830977,1007354,61416,119770,497923,738795,705656,890081,844584,205703,699896,208409,38734,295564,111194,406983,1008351,573999,11013,782556,782459,1027555,865587,938054,393929,886386,132540,421011,585469,189297,1024455,321266,15453,263881,546228,482379,726349,817069,871448) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201448 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201448 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]