SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 555089 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555089 [ RunTime:0.002677s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (875846,260916,942406,41624,50154,259313,604713,486133,350184,869578,800054,911333,421319,460557,722479,391788,488836,547108,924784,408767,296123,890164,819907,626009,586775,897435,874863,903616,621121,403144,875150,490165,225828,973873,722746,109330,959433,288376,351127,677095,36647,639627,405015,468178,124575,776115,564192,354749,1031286,505026,803189,102406,110251,68316,749743,991735,126871,551672,1046765,554309) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555089 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555089 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000900s ]