SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002910s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046611 LIMIT 1 [ RunTime:0.003850s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046611 [ RunTime:0.002626s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (352183,458045,101562,382500,411316,961055,560333,791836,264389,749501,670389,183499,80103,54444,60185,548229,693937,472799,837117,662810,588309,570638,458099,928825,342328,417186,403799,357146,215717,45613,980866,488430,459208,259325,321777,90043,310420,354438,733136,753062,455832,583182,253200,598554,269951,905521,501945,518574,502895,810814,373784,959809,764242,737283,556118,622801,44274,396496,566536,224106) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001744s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004005s ]