SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031970 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031970 [ RunTime:0.001706s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (299510,1005500,806878,104513,858713,973074,42390,381846,757025,641645,1017729,799322,86173,336591,975294,742667,147104,969380,368575,456256,148892,894779,11580,558590,749286,236518,163081,122600,16245,25297,834802,558259,221904,363235,214499,10313,804055,32076,194842,330794,817427,163151,791606,379036,293164,795757,3389,484077,246190,1001458,872681,503872,867746,279109,736471,1019022,371576,158670,147637,656560) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031970 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031970 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]