SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 577223 LIMIT 1 [ RunTime:0.000794s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 577223 [ RunTime:0.001680s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1006210,890012,608413,43355,658139,989191,852115,554412,43648,420639,860831,641462,957547,268640,70515,1029469,370057,93094,528088,798986,440084,240158,410583,169705,276462,851551,964447,768817,792726,590549,258481,596121,384837,86605,799681,86708,206295,1025724,299985,393215,575083,712021,950194,184053,580430,698490,1009347,22199,466784,358983,701297,20522,25819,51245,506543,596476,851535,605338,880666,671717) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 577223 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 577223 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]