SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 905394 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 905394 [ RunTime:0.002290s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (183788,506533,277374,597263,800866,947940,953171,484038,137397,197462,967396,657399,688345,712422,942015,168623,501204,283139,97575,867875,101852,880300,565486,668925,895851,296141,849614,303313,810505,501668,202253,83665,879592,834521,200795,229863,940944,795224,830139,591469,888795,134323,94802,940084,246492,399099,19215,530198,781363,788289,315394,670388,93842,740369,1003810,905774,792959,53563,591214,975689) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 905394 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 905394 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]