SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 434218 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 434218 [ RunTime:0.002001s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (101412,328612,883373,731290,324011,652024,1017437,373662,1045256,851273,548706,518106,688635,308552,273844,232882,768655,463488,863131,199540,947452,486966,675885,280663,311599,546778,42666,751401,110473,992731,333486,1007468,438944,84775,197771,528283,88702,508814,994221,839079,489169,148013,784777,434293,11668,534827,821853,959470,295187,580025,978946,473118,51155,652041,687268,501336,1034828,1040894,329335,944861) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 434218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 434218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000686s ]