SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503842 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503842 [ RunTime:0.002077s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (425269,561703,226852,112420,701753,1005671,59727,845631,64570,150120,765986,434478,62566,220805,199883,31826,112830,278030,393469,762390,274009,990041,630139,312282,589254,262840,175706,837137,154066,237017,389370,91572,782925,525235,853151,865478,619003,315603,966439,390751,756400,628899,584416,21796,875576,285942,969466,963065,185003,950019,153050,79170,605225,1024911,755385,305474,1034304,312559,936629,292446) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503842 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000553s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503842 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]