SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042570 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042570 [ RunTime:0.001414s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (255556,155596,871268,289268,104821,806915,755942,79344,59974,800424,363745,971249,226013,611458,354218,115936,953301,98807,163969,642412,1025326,755958,730874,831187,115463,172879,780645,918798,1005143,225446,917752,721299,477851,198890,913084,192254,48937,315891,599673,24664,80526,1044277,532271,138665,116054,457001,698953,559690,632016,798915,940649,969567,489335,263199,973111,535373,644014,318744,206687,887554) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042570 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042570 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]