SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 141516 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 141516 [ RunTime:0.001970s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (969520,278861,357563,898581,1033221,234755,198921,261128,14455,342204,933515,322439,795560,511882,862173,229176,340313,668675,27491,934610,939380,672834,625092,925374,707375,887909,966331,526215,60381,910373,190662,531228,780458,588077,629403,766806,52348,239969,278781,219757,373131,353818,525335,431154,992519,759239,663237,991056,300206,510828,581262,356294,884312,1029102,417696,343095,309728,163756,586749,359017) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 141516 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000582s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 141516 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]