SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 469084 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 469084 [ RunTime:0.002132s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (439888,1041837,570441,344848,312329,1043403,963317,274162,900196,286073,130380,761914,899265,594413,431737,1036095,871726,490663,979833,907406,622576,520398,820974,796367,386918,3147,518313,736678,1041733,689008,340973,1014081,761794,931164,252939,605927,944269,135406,71495,730088,199283,130072,892588,340253,581688,434661,184056,847919,360256,255431,248811,870627,732962,319199,480871,971524,641331,416547,152129,727066) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 469084 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 469084 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000483s ]