SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001708s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 6828 LIMIT 1 [ RunTime:0.000674s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 6828 [ RunTime:0.001831s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (853319,64545,1048286,658118,165498,682826,34854,109777,315284,147815,829262,96507,927711,661573,332204,497160,174388,547157,800446,33879,196617,407993,611140,169429,697500,656602,777785,456863,570271,935022,73266,224494,96965,323710,808583,236340,713856,788505,147507,460477,215750,988733,382025,849159,476223,377876,692457,146861,683782,71879,372204,90282,504546,203170,270131,484320,307641,651702,890290,716838) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 6828 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000538s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 6828 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002032s ]