SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041300 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041300 [ RunTime:0.002414s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (222528,466257,606934,780970,336921,459700,33922,938666,170867,285941,86965,531141,96956,670423,16061,818000,807633,242371,973700,112529,675294,168671,524320,251618,186339,670045,212109,385082,709008,74435,501143,688332,378164,221131,257909,999032,975551,429083,901545,870880,799217,376468,541034,617459,569117,987775,656102,82774,379576,137604,861826,73425,10922,755467,627898,751875,806866,233705,552541,713407) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000424s ]