SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518653 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518653 [ RunTime:0.001686s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (910763,725549,727711,834580,578286,195062,602967,141016,13451,981940,38373,110867,994380,38894,219654,747306,656810,740737,570190,131592,513784,547796,527507,222178,108898,692208,650340,815789,502219,398822,281347,475117,609156,862338,644181,269104,326477,581943,136584,676893,96941,256714,891534,304801,553648,579965,428171,373529,915396,896457,650101,556778,816422,284778,679539,569029,146009,902952,678436,500840) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000938s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518653 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518653 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]