SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406380 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406380 [ RunTime:0.001924s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (656639,542006,110339,386717,677200,569842,557617,132047,821341,964156,1039839,139947,1005461,694017,866333,769913,163174,1000804,391293,545448,353252,739381,831771,497591,725350,653892,725527,316023,148897,714499,22373,346789,531100,224641,625513,705852,319492,811479,880835,844799,8219,661332,373915,18975,802302,267066,500094,979330,679957,588489,170261,189544,689141,390996,918656,371318,963391,415299,444862,301878) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]