SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 482672 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 482672 [ RunTime:0.001750s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (29210,669963,467187,364346,321507,333123,983480,270925,858032,501659,613856,219173,104742,32530,636894,421137,1023071,557547,620352,231128,15148,543723,800731,545908,248012,681700,988540,781681,835324,437031,512293,340164,871157,557040,940373,356022,591783,849224,501088,290635,372167,114307,876796,915218,4778,485141,821163,717955,644658,400171,36650,922350,996809,25701,9095,639173,260967,126212,740330,145564) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 482672 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 482672 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]