SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001799s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 252009 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 252009 [ RunTime:0.001598s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (980076,929205,522624,456776,185747,265063,595071,837264,244169,159027,597122,382740,635706,504761,955718,155023,497605,294176,322984,841623,256967,427911,398657,760786,475119,773126,738171,547747,119879,519892,731014,671958,712490,100915,40771,836801,367413,847714,573537,939707,654362,712191,951164,755188,450662,894125,450946,967904,292910,1011965,755703,940403,23567,83770,258423,798923,156104,772517,529398,942974) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 252009 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000560s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 252009 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]