SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 597028 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 597028 [ RunTime:0.002666s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (946077,61623,817098,295627,100235,711731,914721,154766,413700,720636,799296,577134,1024743,130804,959656,157976,590928,1011282,415170,277350,32553,388141,413423,221734,964663,341968,386269,637487,345583,741842,562920,421027,903389,973093,1022765,37186,588960,117152,406679,389589,494188,1006236,342614,507678,59373,360284,119336,512116,421632,452089,657191,622672,850626,483710,324775,665375,1009579,104428,812482,1012953) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 597028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 597028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]