SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022138 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022138 [ RunTime:0.002265s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (685684,666046,270112,525853,998773,260680,320017,506353,746915,409180,67496,243464,182209,1004665,1017389,189427,285545,976580,713440,296024,646444,557031,236090,363635,890482,1047168,463449,93266,458972,246257,30217,469928,702719,555252,112364,394513,441700,708205,237955,293878,107828,558430,678734,240323,873185,1040401,875822,563460,1046015,179824,636716,570758,719713,545923,730576,27074,545577,498897,278412,875457) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022138 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022138 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000665s ]