SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473043 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473043 [ RunTime:0.001345s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (87145,1029460,755137,782829,972552,153517,487423,154265,780211,349774,771644,4774,604679,384454,630923,559582,678405,18221,176319,659102,703313,235701,142320,1040686,596776,185142,151669,855278,831639,279829,295091,356520,212008,461498,719238,285088,619468,314547,420355,484923,846452,889706,221682,818983,92589,797735,323058,401522,930301,361002,152060,1001708,113167,179259,48255,368571,186353,443776,107498,884971) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]