SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001468s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1006819 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1006819 [ RunTime:0.005383s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (757311,330090,881450,230224,637389,960414,66458,305386,147307,843688,827307,107710,562804,808969,952067,483499,241011,74363,560498,153093,333875,466485,179025,960967,857830,367369,173896,111407,1014671,17069,666909,731329,648949,210465,643881,325673,348113,571125,126781,365692,123612,196227,42177,749053,201213,788365,775742,924668,877334,1029313,293127,309981,58030,205386,1010576,136840,581272,686394,714453,857691) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001717s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1006819 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1006819 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.006109s ]