SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001646s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409175 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409175 [ RunTime:0.001581s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (841630,12396,335494,985945,159444,324037,684723,307318,882398,831005,128974,629543,399978,181106,914411,635092,719630,546449,276822,408788,54097,908395,362700,756756,555541,561050,668538,406315,1022573,529422,789880,794442,140448,327578,171931,555971,26321,898553,687780,838562,478026,729410,1020417,1005100,24059,682258,673988,865846,737800,17743,166096,646926,510129,604497,665731,1033108,467138,906942,458349,529755) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409175 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000788s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409175 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]