SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1033389 LIMIT 1 [ RunTime:0.001166s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1033389 [ RunTime:0.001939s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (406338,536609,83128,560834,937260,881618,910783,989633,570798,80362,325298,783172,407111,276645,125685,321388,630164,648247,799900,614708,841012,650595,219125,193705,886301,855849,543228,800110,12066,239136,339326,997733,710940,639214,144271,452943,898988,34801,796948,765039,51449,50342,652607,152730,247605,963419,1032286,81189,735926,73726,525563,810255,1023490,813640,256958,197749,465492,565061,205952,432387) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.018558s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1033389 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001809s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1033389 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002707s ]