SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038172 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038172 [ RunTime:0.001500s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (567529,802479,261786,740582,282919,877128,987661,891622,11199,854453,536988,970747,1022791,192746,972803,263923,312256,417779,461489,952433,355320,772486,117566,115288,330909,761854,874904,141242,840024,703886,436760,764934,989986,659156,790705,661685,283596,60071,143413,282653,926181,220145,1034447,689613,1030853,376997,380069,301170,437281,219171,591177,1027566,120179,604625,319376,485616,533939,982780,121028) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038172 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038172 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]