SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 280816 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 280816 [ RunTime:0.003224s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (21847,439562,311869,37863,867430,130213,89714,385217,704239,458,698689,988966,1024145,207219,395295,35986,873283,1016804,181798,627626,127408,279658,1046000,705193,1024895,271887,200482,320677,309121,419042,400761,874464,119427,132058,988999,479712,666137,763796,341695,419749,1046824,543497,287152,705914,149404,694439,687651,1004491,1005896,312035,245112,739880,112503,475540,249604,394292,983893,483064,924055,226482) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001823s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 280816 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 280816 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]