SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001410s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500574 LIMIT 1 [ RunTime:0.001531s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500574 [ RunTime:0.003193s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (171325,3692,330980,462068,789473,959334,555240,430256,443131,236550,1033790,444286,255482,192260,174698,295064,536201,569031,262689,21281,802309,945780,510586,361930,162951,276486,204013,1023389,122692,37691,75843,608882,109611,651582,250398,175749,976985,631750,254947,585501,912377,17130,775954,203061,565363,479080,850119,34176,386071,863395,482858,631281,120844,861341,394925,229367,930863,630656,838497,224895) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001888s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500574 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001961s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500574 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000771s ]