SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 393971 LIMIT 1 [ RunTime:0.000444s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 393971 [ RunTime:0.002618s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (23281,435758,561203,650446,337172,211827,422753,983577,118771,442540,637416,951327,973377,513594,223175,859508,513751,831185,33561,291106,566653,921856,145103,903342,372327,522012,518304,659918,210398,811619,142627,94758,612680,943313,999514,743474,163927,386174,804114,178707,621428,1018370,243894,502289,254392,324060,794604,741679,250208,249006,718237,263912,232539,349531,100469,325896,900410,882260,535786,1040203) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 393971 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 393971 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]