SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438314 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438314 [ RunTime:0.001596s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (859592,419490,211823,766361,997216,148329,940265,109969,132172,79257,109556,632023,152797,570714,900667,922499,973497,759615,688529,687770,929458,1044688,348798,399879,294903,446728,591211,1027103,424305,334683,753968,120477,418838,394096,795642,371747,287520,991203,609217,105912,682436,856525,321324,640053,1011088,565644,431842,717346,523670,505618,524675,816974,798698,598058,41054,185677,429449,340026,340267,1021917) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004862s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438314 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438314 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000407s ]