SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 807093 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 807093 [ RunTime:0.002754s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (654429,61154,383782,874394,12818,675911,903959,716097,587450,711715,141573,965689,1032578,320274,893458,763353,1004767,678216,32819,362853,22175,43214,414685,258231,87314,253302,980718,819759,953121,1024234,444303,198823,279514,320096,386378,937808,295886,637112,286878,706246,399534,804269,112782,137412,706720,708095,651658,521070,253438,109323,1028430,265656,1003484,396825,461819,1007736,24245,490695,142592,892482) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 807093 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 807093 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002443s ]