SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 330039 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 330039 [ RunTime:0.001765s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (51937,998697,358390,295407,1034398,274718,792289,184818,1048544,258580,516674,332154,129581,209073,413230,164343,248643,936224,596224,238231,347773,260202,545253,903803,860008,856603,837617,852058,762481,792468,313024,414963,771199,811246,148248,491186,739323,922458,401114,155658,577463,370957,183628,515878,290009,520584,696907,657011,121368,859545,793372,709943,342751,860841,478346,797405,729752,769466,888863,528328) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 330039 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 330039 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]