SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 474512 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 474512 [ RunTime:0.002879s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (4577,134109,692918,320489,709114,144944,365516,797069,701318,511451,483148,812828,138603,158442,597893,751539,269082,819664,877787,566782,1036810,567141,34274,1008924,342403,692298,906071,200281,552910,435880,1856,923773,798974,848094,860122,314041,823663,722728,496215,604013,744453,611226,706214,956624,106017,942084,977674,113506,631118,1045893,976388,30421,522177,908461,378252,1009311,265159,45993,70485,199674) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 474512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 474512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001042s ]