SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023115 LIMIT 1 [ RunTime:0.001019s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023115 [ RunTime:0.006031s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (930567,281971,353005,47956,632975,496039,423513,187675,173959,466640,669781,2067,452277,743511,791184,918267,174056,350731,366136,125167,625061,490914,398494,298456,692592,987804,480313,113586,738082,223192,750210,115878,996566,1022958,969723,887701,801615,575875,215726,657864,1025825,887767,46752,808975,1029541,780821,181988,770060,1042273,36168,335139,500644,574405,277718,837241,219726,425928,69922,192989,947039) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023115 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023115 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]